How to: Set command button defaults in forms.
Solution:
In Form Design view, select the 'View' menu and select 'Properties'. Click 'Command Button'. Set the desired defaults.
NOTE: Using this procedure will only affect new controls on the current form.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
Form property sheet
6) Click the 'Command Button' button in the toolbox. (The Default Command Button dialog box appears.)
7) Click the 'Format' tab from the Default Command Button dialog box.
8) Click on the 'Picture Type' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down arrow appears.)
b) Do one of the following to specify whether to store a picture as an embedded or linked object:
1] Select 'Embedded' from the 'Picture Type' drop-down list to store a picture as an embedded object.
2] Select 'Linked' from the 'Picture Type' drop-down list to store a picture as a linked object.
9) Click on the 'Visible' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine whether to have the label visible:
1] Select 'Yes' from the 'Visible' drop-down list to have the label visible on the form.
2] Select 'No' from the 'Visible' drop-down list for the label not to be visible on the form.
10) Click on the 'Display When' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine when to display the label.
1] Select 'Always' from the 'Display When' drop-down list for the label to always appear on the screen and printed.
2] Select 'Print Only' from the 'Display When' drop-down list for the label to only appear when printed, not on the screen.
3] Select 'Screen Only' from the 'Display When' drop-down list for the label to only appear on the screen, not when printed.
11) Type the desired width of the label in the 'Width' box.
12) Type the desired height of the label in the 'Height' box.
13) Click on the 'Fore Color' box. (A Build button appears.)
a) Click the 'Build' button. (The Color dialog box appears.)
b) Select the desired color.
c) Click 'OK'. (The Default Command Button dialog box reappears.)
14) Click on the 'Font Name' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down arrow appears.)
b) Select the desired font from the 'Font Name' drop-down list.
15) Click on the 'Font Size' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Select the desired size for the font from the 'Font Size' drop-down list.
16) Click on the 'Font Weight' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Select the desired weight of the font from the 'Font Weight' drop-down list.
17) Click on the 'Font Italic' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to italicize text in the label:
1] Select 'Yes' from the 'Font Italic' drop-down list to italicize the text for a label.
2] Select 'No' from the 'Font Italic' drop-down list for the text in a label to remain normal.
18) Click on the 'Font Underline' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to underline text in the label:
1] Select 'Yes' from the 'Font Underline' drop-down list to underline the text for a label.
2] Select 'No' from the 'Font Underline' drop-down list for the text in a label to remain normal.
19) Click on the 'Auto Label' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine whether a label automatically appears with a control:
1] Select 'Yes' from the 'Auto Label' drop-down list to automatically have the label inserted on the form.
2] Select 'No' from the 'Auto Label' drop-down list for the label not be to automatically be inserted on the form.
20) Click on the 'Add Colon' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine whether a colon follows the text in a label:
1] Select 'Yes' from the 'Add Colon' drop-down list to have a colon follow the text in labels.
2] Select 'No' from the 'Add Colon' drop-down list to not have a colon follow the text in labels.
21) Type the dimension for the horizontal axis for the label text from the upper-left corner of the label's attached control in the 'Label X' box.
22) Type the dimension for the vertical axis for the label text from the upper-left corner of the label's attached control in the 'Label Y' box.
23) Click the 'Label Align' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine the distance between the label and the control's upper-left corner:
1] Select 'General' from the 'Label Align' drop-down list to use a general alignment.
2] Select 'Left' from the 'Label Align' drop-down list to align the distance between the control's upper-left corner and the left edge of the label.
3] Select 'Right' from the 'Label Align' drop-down list to align the distance between the control's upper-left corner and the right edge of the label.
4] Select 'Center' from the 'Label Align' drop-down list to align the distance between the control's upper-left corner and the center of the label.
24) Select the 'File' menu and select 'Save' to save changes to the form.
